The Registration Sheet Is Starting to Break

Spreadsheets are wonderfully easy to start with when organizing school information. However, keeping all records—such as students, courses, teachers, and sign-ups—in one giant, overloaded sheet causes data to repeat endlessly and systems to break. When a student takes several classes, their personal details must be written down over and over again, creating messy duplication and serious maintenance challenges.

Core Concepts of Database Design

Data Duplication: When a course contains many students, course and teacher details repeat across many rows, wasting space and inviting errors.
Update Anomalies: If Sam changes his phone number and we only update it in one place, the sheet becomes full of conflicting information.
Requirement Analysis: Building a dependable design starts with spotting these problems and identifying entities, attributes, and relationships.

Why We Need Structure

A well-designed database prevents errors—such as letting the exact same student-course pair appear twice by mistake. By separating distinct concepts into properly structured tables, each row represents a single, consistent class of object, ensuring reliable operations.

Design Principle

Every design decision must be directly traceable to a stated requirement rather than assumed conventions, ensuring the architecture accurately models the real world.

The Registration Sheet Is Starting to Break

Look closely at Building a dependable database design starts with careful analysis of domain requirements.

QUESTION 1

What is the primary drawback of storing students, courses, teachers, and sign-ups in a single flat spreadsheet?

It prevents students from enrolling in multiple classes.

It automatically organizes information into separate tables.

It causes data duplication and update anomalies.

It processes queries much faster than other methods.

QUESTION 2

What happens in a flat registration sheet when a student takes three different classes?

Their personal details are stored once in a master file.

Their name, student ID, and phone number are copied onto three different rows.

The system automatically creates a relationship table.

Their enrolment is rejected due to duplication rules.

QUESTION 3

Why does updating a student's phone number in only one row of an unnormalized sheet cause problems?

It converts the spreadsheet into a relational database.

It deletes the student's course records entirely.

It automatically updates all other rows in the background.

It creates conflicting information because other rows retain the old phone number.

QUESTION 4

Building a dependable database design starts with which fundamental step?

Eliminating all relationships between tables.

Spotting problems in flat sheets and figuring out what information needs to be tracked.

Assigning random primary keys to every column.

Writing complex SQL code without a plan.

QUESTION 5

Which of the following is a key goal of transitioning from a flat sheet to a relational database?

Preventing errors such as duplicate student-course pairs and ensuring data integrity.

Removing the need to track teachers and courses.

Increasing the amount of repeated data to ensure backup safety.

Combining all school records into a single cell.

The Registration Sheet Is Starting to Break: In-Class Exercise

Use the content on this page to complete the exercise.

The school stores students, courses, teachers, and enrolment status in one large sheet. - A student can take several courses, so student details repeat. - A course can contain many students, so course and teacher details repeat. - The system must prevent the same student–course pair from appearing twice.

Explain the main idea of “The Registration Sheet Is Starting to Break”.

Answer:
The school stores students, courses, teachers, and enrolment status in one large sheet. - A student can take several courses, so student details repeat. - A course can contain many students, so course and teacher details repeat. - The system must prevent the same student–course pair from appearing twice.

Explain the main idea of “The Registration Sheet Is Starting to Break”.